const SQL = {
    queryAll: 'select * from biaoming order by si asc',   // 查询并升序排序
    updateArt: 'update biaoming set si=? where si=?',// 更改
    deleteArt: 'delete from biaoming where si=?', // 删除
    addArt: 'insert into biaoming values (?,?,?,?,?,?)', //添加
    queryByIndex: 'select * from biaoming where si=?',  // 序号索引查询
    queryByLike: 'select * from biaoming where title like ?', // 模糊查询
    
    queryByUsername:'select * from users where username=?',
    queryByNamePassword:'select * from users where username=?',
    registryUser:'insert into users(username,password) values (?,?)'
  }
  
  module.exports = SQL
  
  